<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class AlterTableFuYouBillRecordAddIndex extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('mybank_fuyou_bill_record', function (Blueprint $table) {

            $table->index(['shopId'], 'idx_shopId');
            $table->index(['kfOrderNo'], 'idx_kfOrderNo');
            $table->index(['mybankMerchantId'], 'idx_mybankMerchantId');
            $table->index(['fyMerchantId'], 'idx_fyMerchantId');
            $table->index(['merchantOrderNo'], 'idx_merchantOrderNo');
            $table->index(['originalTransactionOrderNo'], 'idx_originalTransactionOrderNo');
            $table->index(['mybankOrderNo'], 'idx_mybankOrderNo');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('mybank_fuyou_bill_record', function (Blueprint $table) {
            $table->dropIndex('idx_shopId');
            $table->dropIndex('idx_kfOrderNo');
            $table->dropIndex('idx_mybankMerchantId');
            $table->dropIndex('idx_fyMerchantId');
            $table->dropIndex('idx_merchantOrderNo');
            $table->dropIndex('idx_originalTransactionOrderNo');
            $table->dropIndex('idx_mybankOrderNo');
        });
    }
}
